package com.fowo.api.model.loan.monthly.balance;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 货款月结 导入导出辅助模型 */
@Getter
@Setter
public class LoanMonthlyBalanceExcelPo {

  @NotNull(message = "供应商不能为空")
  @Size(max = 50, message = "供应商长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "*供应商")
  private String supplierNameSupplierName;

  @ExcelIgnore
  @ExcelProperty(value = "*供应商")
  private Long supplierName;

  @Size(max = 50, message = "采购单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "采购单号")
  private String purchaseOrderCode;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "采购方")
  private String applicationDepName;

  @ExcelIgnore
  @ExcelProperty(value = "采购方")
  private Long applicationDep;

  @Size(max = 50, message = "入库单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "入库单号")
  private String orderSn;

  @Size(max = 50, message = "仓库长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓库")
  private String widName;

  @ExcelIgnore
  @ExcelProperty(value = "仓库")
  private Long wid;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "入库时间")
  private java.util.Date warehousingDate;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "结算账期")
  private java.util.Date closingPeriod;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "应付款日")
  private java.util.Date dueDate;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "状态")
  private String status;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "请款维度")
  private String withdrawDimension;

  @ExcelProperty(value = "采购量")
  private Integer purchaseQuantity;

  @Size(max = 50, message = "入库量长度不能超过20")
  @ExcelProperty(value = "入库量")
  private Integer totalNum;

  @ExcelProperty(value = "采购金额")
  private java.math.BigDecimal purchaseMoney;

  @ExcelProperty(value = "到货金额")
  private java.math.BigDecimal aogMoney;

  @ExcelProperty(value = "请款金额")
  private java.math.BigDecimal qkMoney;

  @ExcelProperty(value = "未申请金额")
  private java.math.BigDecimal notApply;

  @ExcelProperty(value = "折扣金额")
  private java.math.BigDecimal discountAmount;

  @Size(max = 50, message = "请款单号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "请款单号")
  private String qkSn;

  @Size(max = 50, message = "入库员长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "入库员")
  private String stockinUidName;

  @ExcelIgnore
  @ExcelProperty(value = "入库员")
  private Long stockinUid;

  @Size(max = 50, message = "采购员长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "采购员")
  private String optUidName;

  @ExcelIgnore
  @ExcelProperty(value = "采购员")
  private Long optUid;
}
